The Maintain Customer Part Numbers (IM40) program can be used to build a cross-reference between your customer’s part numbers and your own in-house product codes from the Maintain Inventory Master (IM13) program. The cross-reference is built against a customer’s Paying Office code in Maintain Customer Master (SU13).

  • For example, using customer code 'L201' you enter the customer’s part number 'BAS0099F' and cross reference it to your product code 'BAS0099'. When you enter the customer’s part number in the 'Product' field on the Lines folder of Enter Order/Quotes (OE30), your in-house product code is automatically accessed and displayed in the Product field. The customer’s part number is then displayed in the 'Cust’s No' field as a reference.

  • As a result, the Customer’s product number is printed on the Sales Order and on the Invoice.

  • If a chain or group of customer’s share a common paying office and reference a common part number list, then the cross-references are built once under the paying office customer code but will be accessed any time an order/invoice is processed for any of the customers in the chain/group.

The following list defines every field on IM40:

  • Paying Office - enter or select from the query the Paying Office to be used for the current record. The Paying Office field is used to specify the customer code you wish to create, review or modify Customer Product Codes against. Customer part number cross-references are built against the customer’s paying office code. If a chain or group of customers share a common paying office and reference a common part number list, then the cross-references are built once under the paying office customer code but will be accessed any time an order/invoice is processed for any of the customers in the chain/group.

  • Customer’s Product Code - enter the Customer's Product Code. You can enter a maximum of 21 alpha numeric characters in this field. The Customer's Product Code is used to specify the customer part number that your customer wishes to use when ordering one of your product codes. Note: The same Customer's Product Code can be assigned to more than one of your in-house product codes for any given Paying Office. If this is the case when an order is entered for the Paying Office and you enter the Customer’s Product Code in the 'Product' field on the Lines folder of OE30 or Enter Inv/Direct Bills/Credits (IN41), the following message displays: "Customer product code ‘XXXXXXXX’ points to multiple In-house codes. Re-enter using the In-house product code. OK".

  • Our Product Code - enter or select from the query the in-house product code that you wish to cross reference to the Customer’s Product Code. The product code entered must exist in IM13 in order to update the record. Whenever your customer’s part number is entered on an order or invoice, the product code entered here will be identified and used as if it had been entered directly.

The following Product Information fields are used to collect information on your customer's product code specification. The information is collected and used for custom applications when required. Ask your Enterprise Business Consultant for further details. These fields are not mandatory.

  • Retail Price - can be used to store your customer’s retail selling price.

  • Custom 1 - enter a maximum of 21 alpha numeric characters in this field.

  • Custom 2 - enter a numeric value in this field.

  • Custom 3 - enter a numeric value in this field.

  • Custom 4 - enter a maximum of 21 alpha numeric characters in this field.

  • List Box - the list box displays the information entered for the Customer’s Code, Our Code, Retail, Custom 1, Custom 2, Custom 3 and Custom 4. You can recall a record for review or modification by double clicking on a line in the list box.

The following table outlines the functionality of each button on the IM40:

Button Label Icon Functionality
Delete All Delete all of the current Customer’s Part Numbers Deletes all of the customer's product code sub-records for the current Paying Office.
Copy Copy Customer Product Data Copies records from one Paying Office to another Paying Office. This feature is used to set up a chain of customers that share common part numbers but do not share the same paying office. The part number list is defined under one customer in the chain and then copied to each of the other customers in the chain. Note: Subsequent additions to their part number list need to be added individually for each customer.

When you click Copy, the Copy Customer Product Data window opens.

  • In the From field enter or select from the query the Paying Office you wish to copy the Customer Product Data from.
  • In the To field enter or select from the query the Paying Office you wish to copy the Customer Product Data to.
  • Click Copy to complete the process or click Cancel to abandon the copy process.
Submit Submit Saves the information entered for the current record and clears all of the product information fields.
Delete Delete Deletes the current product information record.
Clear Clear Clears all of the fields.

Maintain Cusotmer Part Numbers
Maintain Customer Part Numbers (IM40)